SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001414s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401034 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401034 [ RunTime:0.005470s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (698955,1046063,456028,394917,13777,695339,211354,698449,690631,337459,813835,81975,234303,823853,747765,423138,903694,755678,592851,678379,66290,547589,568779,695659,623980,836,974524,541053,510241,742695,943705,667592,389544,837318,906433,76506,944647,755824,818069,300423,574586,140125,337704,554719,182732,2907,31852,961516,479858,985134,42824,895689,941040,460584,170774,546280,682880,39003,592230,40546) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401034 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401034 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001373s ]