SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 399114 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 399114 [ RunTime:0.001571s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (431812,890041,678731,101180,589886,1047994,976548,725418,922667,1000759,893254,1035453,272876,799410,60745,308519,685893,1047506,380477,853528,920376,547003,542170,245073,468497,703886,104022,1040404,246883,684402,794112,647773,22519,955308,218468,793020,41659,966208,941312,724048,161686,954579,347231,178128,706160,454088,789813,667653,763117,1016778,124209,438148,481726,303540,993968,971571,320462,462930,806220,111656) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 399114 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 399114 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000417s ]