SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565583 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565583 [ RunTime:0.001465s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (302865,891218,612981,647227,712810,588409,786966,114796,98378,592291,830572,468076,78040,955027,78965,792286,239213,162806,630655,410825,1018468,561660,947115,36551,14112,552641,953142,283139,403430,110037,934100,359747,390571,771284,517880,150347,1035782,740358,216679,479691,419053,323250,720410,913127,590641,375591,362369,116956,975551,148967,476094,473916,896912,652600,685963,961880,371605,444318,492890,667496) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]