SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 872010 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 872010 [ RunTime:0.001589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (106272,501678,845815,993747,260691,821591,665255,845229,314434,954839,970484,676103,793146,1010772,214491,545689,708413,615117,1013365,647843,51059,687331,947798,648810,270483,436508,735122,818536,734411,961137,696960,365244,316782,1013928,709350,816617,531713,580458,546468,1003248,265205,646963,583493,829547,959296,855949,428981,608417,492314,347251,849477,24356,960224,507278,957475,373550,813863,584693,1046977,209071) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000950s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 872010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 872010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000427s ]