SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001419s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 267841 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 267841 [ RunTime:0.002060s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (100686,530806,340953,298923,417662,180734,930860,741361,783372,949520,90702,838496,332117,99004,678808,520429,734512,991426,471108,895571,1013653,15084,229708,521094,958585,772232,681674,19119,391818,826034,398476,139392,378428,68094,818616,399280,703046,33289,368418,1005253,264736,829691,304982,484466,776979,286657,908661,926593,154088,335898,797858,313471,856711,233979,784765,226216,1038118,673907,941832,138390) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 267841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 267841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]