SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 817140 LIMIT 1 [ RunTime:0.000471s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 817140 [ RunTime:0.001516s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (122948,258180,975100,272511,313447,30681,619599,1019802,541853,729635,112829,393569,571674,681987,194322,787220,242390,837331,582634,849359,554509,425736,747250,406497,985953,100334,89006,259405,747583,655353,386580,281466,678151,538204,119496,936079,387497,846383,203949,623986,805515,268676,89611,194844,123762,573513,277296,748518,405823,758923,498774,352273,555434,813208,259383,452847,469672,606148,626621,77314) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001743s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 817140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 817140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]