SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412113 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412113 [ RunTime:0.001691s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (704384,1032755,110327,479517,984183,362682,789984,11375,149486,590647,219541,135733,340431,817575,947751,390761,348765,284726,989090,794205,340460,790188,124956,285495,1030845,931102,987080,706011,799321,441509,247508,139697,794463,624745,964663,1038257,760545,167897,479774,1023426,799856,167159,44033,1041903,776930,660359,116298,149399,855154,470278,66793,695335,426786,56632,343885,1030022,167172,505634,999941,360620) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412113 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412113 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]