SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003902s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488399 LIMIT 1 [ RunTime:0.003503s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488399 [ RunTime:0.004723s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401647,437268,641060,4885,316603,902434,5722,625453,927251,879625,924276,640544,133078,764020,790536,936713,351702,191756,395072,1021051,538084,578039,882630,256757,907190,125789,81581,766824,154678,401486,549818,293526,189322,259543,459593,549573,85749,493860,681487,858396,493557,138168,233727,716157,484377,986223,232144,665240,553363,895020,982149,580111,673271,548453,216590,1011544,9537,364977,230693,529083) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001574s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488399 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488399 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001151s ]