SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381045 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381045 [ RunTime:0.002183s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (447365,940387,210045,98258,733126,984730,116218,632877,147321,310551,835184,288379,467768,757764,272610,633058,586060,937088,848844,798852,756943,386632,975470,352588,485977,524536,928113,733427,109094,166419,979433,842536,977997,171212,96284,679349,851242,41237,77877,414068,178203,697199,235934,290869,555783,495303,7835,756080,255274,945701,125764,985295,864494,52406,138586,598258,836289,100785,186754,371366) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381045 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381045 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]