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` = 379164 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 379164 [ RunTime:0.004199s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201503,838576,994142,79174,108438,303431,574465,676751,1015351,796348,1036634,1006065,290997,1010662,126424,786828,1740,912648,210173,484301,861798,2091,1044675,351937,474675,75099,805697,1035059,149142,640833,403044,582471,268056,462718,685037,719813,505834,477811,313962,752774,635275,401866,566525,137376,66190,562608,563399,294889,319207,702659,578865,884850,969204,914706,993355,1002334,16766,540169,135873,323927) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 379164 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 379164 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]