SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 591160 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 591160 [ RunTime:0.001345s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (451801,135301,977145,473417,703283,838157,90575,574539,272409,454213,261913,5375,316321,502666,724095,539143,313016,315326,870314,1042109,985569,862407,207799,59556,472177,106476,287911,966169,893682,624706,254863,729505,63287,98354,963005,296451,78594,483943,47624,733021,600245,379691,460713,60633,753639,186773,974407,386313,210580,643138,436323,40041,964601,5400,389908,372049,881744,275194,464561,373825) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 591160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 591160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]