SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 336757 LIMIT 1 [ RunTime:0.000875s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 336757 [ RunTime:0.001532s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (117940,162837,964476,279746,139353,521888,930340,532732,730826,121433,351512,29169,581603,653660,49003,86671,448384,165190,1005834,377890,540295,700581,142829,587736,80767,972114,585194,64295,154933,389130,594330,34191,836528,38058,309725,1007871,381773,590857,765970,46771,980074,528405,333713,957508,1027915,943505,131050,624465,812859,144289,649901,663577,92520,194551,206328,1002450,392223,967074,159857,905932) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 336757 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 336757 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]