SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101583 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101583 [ RunTime:0.001848s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (447463,627108,443263,716437,82771,1001343,451066,702592,934117,294077,820439,830594,104454,557759,368124,952721,945742,107286,821234,145232,805515,438264,506976,744382,873696,315180,976979,122568,612910,630746,141129,776064,159366,416996,101095,833748,231772,932902,298586,456840,647730,754063,334796,444751,875641,178854,767817,5933,948037,901531,905375,770094,589116,598778,46838,3756,642173,721909,573309,245241) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]