SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017306 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017306 [ RunTime:0.001883s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (995907,397415,314670,344491,947353,831760,578304,429136,12533,182042,40335,595978,741790,957417,448004,901746,1026678,429296,20447,1022524,981168,87407,512191,229893,700497,222473,900580,593457,146414,38472,932549,885626,878681,721471,257593,593644,484387,198036,139536,555562,121430,516065,634636,107186,915418,144850,973698,392711,53822,313411,630887,98326,939358,828841,283143,153150,146382,478795,952921,722269) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017306 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000548s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017306 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]