SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564616 LIMIT 1 [ RunTime:0.000441s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564616 [ RunTime:0.001626s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (189010,131380,376736,1048821,375516,824983,529188,113031,301019,562298,464622,587399,992285,907091,979504,613736,145021,505911,802548,529469,613765,18054,440427,1034928,587245,359884,112472,878492,448504,867847,447494,954784,359821,211560,898937,551626,208052,112694,751505,307725,342390,280655,151688,52494,412324,935173,223025,569957,976837,405975,728068,267332,854724,647809,99236,755510,899305,438738,233744,665142) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564616 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564616 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]