SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 344873 LIMIT 1 [ RunTime:0.003448s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 344873 [ RunTime:0.001773s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (569314,369898,52835,268080,931097,772280,477156,40122,365945,364795,508298,973767,389252,534186,788924,466826,327531,867384,475939,583129,1017963,264737,321843,234319,117985,167326,383414,8492,944761,518534,659417,564876,535439,604530,183346,59215,188770,790644,635481,869689,600600,624400,368014,482946,864829,292321,510688,959352,626734,831442,236430,393515,371630,1014458,14009,3540,784325,720835,747173,103821) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 344873 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 344873 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000408s ]