SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 91401 LIMIT 1 [ RunTime:0.000865s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 91401 [ RunTime:0.003409s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (891029,34472,558803,685713,452602,164019,155560,452529,197117,810807,116076,940972,393656,568168,1032121,51110,937584,240427,454916,1011542,991552,843930,314824,529305,90818,268284,112538,889516,864408,52605,67923,88814,726174,713869,1038004,814176,645891,351532,234465,994480,392180,244106,652442,89983,733174,378712,1023801,69968,886534,86572,280497,608048,291579,392842,453251,388204,485640,736783,250409,786325) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003637s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 91401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000754s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 91401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004311s ]