SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 204653 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 204653 [ RunTime:0.002416s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (864873,1036777,53553,686582,198506,591482,969934,323688,883735,135836,976774,306273,995056,997951,68138,331844,887473,922983,791592,897280,402904,513300,375152,740029,901418,450444,199059,804563,369066,912185,980379,630918,53368,333031,620949,784637,646204,883183,987642,860350,827920,55271,890393,617027,154318,998243,981933,488010,900450,793189,973257,57308,797398,554836,719069,587291,684966,697623,741390,694406) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 204653 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 204653 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]