SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418704 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418704 [ RunTime:0.001969s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (572654,301938,332637,713784,565146,542067,70484,137174,281306,70718,407643,116913,426544,290475,1034804,2397,269087,603069,434327,115585,139522,729982,545500,831743,440726,841671,962299,918131,382225,753375,774089,8851,413964,313185,63832,604968,186208,375593,294869,852018,719269,541038,611572,279587,625600,806931,925179,819911,217163,959959,391599,888242,561983,289593,935066,22991,357223,944613,361644,344271) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418704 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418704 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000649s ]