SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491804 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491804 [ RunTime:0.002367s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (180001,611856,16532,515152,154255,467401,803357,5670,746151,690958,127844,400690,607428,610263,565377,829161,985585,274763,403709,639440,246531,354288,359854,544129,172284,903457,313023,503223,211939,689211,643011,375831,578536,631076,382603,180671,120429,225093,765197,344059,260374,674554,567612,475356,280290,1003806,451347,399624,313780,68098,350992,677758,403446,869210,119079,718694,1015683,694970,60323,449002) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491804 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491804 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]