SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415454 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415454 [ RunTime:0.003297s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (570005,789568,533348,904294,112270,669457,139121,685503,1046500,41282,785667,785933,501681,664055,415168,251630,203928,436505,187139,410310,24377,240468,461733,527237,886091,70485,529557,442579,592068,322544,992164,250314,843744,471548,443288,721087,317311,583805,299445,635981,592460,174552,541758,476035,23025,216686,824661,489779,60597,111540,583514,528422,813742,268622,686526,420819,942203,33517,417400,890570) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415454 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415454 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]