SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017532 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017532 [ RunTime:0.001449s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (274995,112444,461096,701883,320435,427196,609428,798158,325148,881820,982619,1025761,612274,419095,840211,45694,147219,8183,213735,308273,333097,87370,59592,860043,1022361,250032,364530,158585,532507,1036599,724683,917368,363679,75662,650654,248772,342926,878681,244389,1027368,160515,213227,861898,312602,127373,607011,634803,810677,291200,317825,282180,617608,441883,667836,969446,443764,392682,422447,106932,872017) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017532 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017532 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]