SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001524s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531963 LIMIT 1 [ RunTime:0.000652s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531963 [ RunTime:0.003723s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (74315,478,474627,722926,169406,884123,46562,36288,173643,930693,4555,410203,931650,169043,163925,846785,83738,81552,744167,391332,454250,546196,649790,816579,527950,1044580,675799,828968,66547,73566,56122,436514,49370,622698,756714,532548,752839,508298,61452,733550,680627,566106,846680,204678,145668,862746,641679,190407,537082,929250,183629,383221,664089,159012,277371,190305,633588,979405,890957,143527) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531963 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531963 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001182s ]