SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001343s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543810 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543810 [ RunTime:0.001561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (46359,189851,906476,806583,925608,646481,974961,48482,67462,177016,885695,736203,916830,29330,926910,48767,237486,877088,1002667,550385,745252,101875,884762,562686,263542,922892,443638,69014,875941,660311,34021,138026,884587,316843,579887,521352,783138,400732,369920,818322,493071,638884,509257,775138,36580,431410,142205,143562,665917,747952,767763,138128,79210,938013,488976,47433,266868,473702,698330,928339) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]