SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002412s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034418 LIMIT 1 [ RunTime:0.000977s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034418 [ RunTime:0.001702s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (197104,898232,938327,475138,664866,149918,205900,200330,476968,431273,991764,132649,530958,27482,95866,178450,566804,152177,649001,376468,391938,837729,991419,694084,367068,875184,345245,751125,509520,445423,1028638,921589,33587,368853,244072,465444,679914,207901,119430,2386,940162,993051,858427,89238,915586,228489,661717,349494,264239,915875,764802,538746,201135,372060,186873,547075,811985,425067,477906,863472) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]