SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 471954 LIMIT 1 [ RunTime:0.000448s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 471954 [ RunTime:0.002300s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (301031,454755,393664,356419,377301,242325,487754,780677,669640,626505,470275,915597,565341,1030065,1025198,1036859,928570,248874,133065,28077,179412,1001641,692383,299453,569866,160789,794639,929976,973972,878997,216492,269876,651214,356811,1039331,362039,142947,385375,626417,550352,665162,256607,427798,995939,1039287,833523,609232,399916,833328,738398,440093,317377,169110,914795,752923,738286,93676,214119,1037676,988781) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001592s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 471954 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 471954 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000659s ]