SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450057 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450057 [ RunTime:0.001557s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (346229,555658,21451,596773,90085,36199,567031,736432,68515,43231,259506,145683,380363,754136,288181,925589,359039,951645,844890,601001,217617,747208,213057,127559,169231,387771,910807,919807,280248,290113,55521,428722,221975,327085,956661,5938,621671,149456,484780,368478,612015,688481,514273,394902,202141,68625,317618,333224,779387,279914,27606,492085,768025,400619,1006401,653176,999090,18533,763839,513643) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000935s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450057 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450057 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]