SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520638 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520638 [ RunTime:0.001570s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1028675,587792,43253,926349,87121,125762,1025758,746099,282633,502729,99399,134165,804145,639340,83126,987098,893466,169945,29357,269691,973951,579109,642781,1045828,502397,597799,285274,19576,398226,951995,325540,1042909,656567,714706,988589,855629,765658,108041,268790,118030,241184,581635,439689,658612,633735,559032,376479,929633,693436,396807,834467,329890,565808,879033,381694,579985,189919,782544,326032,805942) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520638 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520638 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]