SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485223 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485223 [ RunTime:0.001861s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (186078,343266,288242,527745,605916,894760,990225,585259,805623,519814,930173,850698,623189,877090,656803,617306,959167,380724,149703,771608,455983,227133,770881,2480,129290,918493,426146,737330,525789,718243,278875,27426,544345,924738,790825,241021,9765,354142,78055,455256,202570,287753,887589,434154,338179,131264,294606,706378,368809,705965,701913,595422,775233,459666,568006,532297,174085,328370,794623,731199) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485223 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485223 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]