SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419060 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419060 [ RunTime:0.001694s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (419690,64791,113753,943324,306026,181254,963716,93628,189263,229490,166791,387454,74567,670572,126464,399228,974600,512294,632452,28645,566658,863268,456427,99772,387226,403216,603540,401472,17002,433583,709817,209698,869307,661627,902196,342838,932919,948379,269231,285911,480992,7069,66833,372518,30008,580202,727456,187631,721592,324279,882354,851692,869783,748025,34112,294914,606823,823662,574438,539453) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419060 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000600s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419060 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]