SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 93180 LIMIT 1 [ RunTime:0.000762s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 93180 [ RunTime:0.001624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (964245,815123,572381,50280,929220,1033615,389568,796532,766036,369364,954278,119688,438223,968237,41311,164788,371931,372839,21706,462324,57779,798996,216677,402082,771387,859031,1024698,910149,15512,425526,444170,199509,688626,510817,801338,965086,86334,249164,951810,29000,791650,494006,160267,787054,629446,250777,809570,862504,609596,35677,128300,298266,200768,870691,856657,435787,83106,174735,731282,861305) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 93180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000598s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 93180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]