SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011436 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011436 [ RunTime:0.001640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (621497,847173,320807,416494,429716,407391,325071,798661,907425,193542,436708,527077,722512,588133,970397,86622,861189,524091,45645,615821,333896,528397,454288,446296,678415,230080,525833,11510,60038,638130,766670,238804,629065,1026531,93210,690221,492553,101236,52697,440647,544187,245719,668537,803667,841096,853140,835226,45491,301309,347716,693512,683254,756530,612319,572549,279254,343879,418186,498502,921558) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011436 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011436 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]