SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 574509 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 574509 [ RunTime:0.002659s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (4033,467880,48700,180310,498005,1719,895352,114495,274761,251727,173841,100836,692965,961001,336557,513204,872116,791749,120474,894706,193753,881178,804109,956172,520282,592001,899076,483176,570075,645709,897157,504179,530086,729228,286372,88752,998278,739036,818201,124496,1009570,1013255,350303,116517,763880,881008,433790,241195,55805,217415,35843,821190,753841,319141,774869,884381,983663,922121,354819,740504) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 574509 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 574509 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]