SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 573822 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 573822 [ RunTime:0.001756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (587902,852779,647708,505764,25389,170409,629436,29454,109633,858798,780370,428212,764007,829011,517487,85245,1018703,726857,494299,251736,937781,418499,28317,446795,417874,479739,188450,570987,46754,546493,689558,749622,180241,708085,726506,503918,508684,371277,268280,105551,604631,545383,338603,826933,762746,183971,215707,1008845,350288,190067,670650,1031062,432749,1038984,23020,744151,848832,173751,21143,279407) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 573822 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 573822 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003887s ]