SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 701418 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 701418 [ RunTime:0.001656s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (197817,870961,71041,692974,640883,219263,747243,1014832,474129,49885,652247,983629,158679,944219,70577,790034,437673,252768,241485,338494,815478,171227,860739,235518,46952,69155,199966,649713,1039809,624358,936834,605420,658338,825399,105841,190120,450142,215952,915183,565839,249610,352912,984583,678857,365817,1008200,928300,636677,738040,301153,68247,650774,195303,368599,396790,637675,92274,158530,516967,316189) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 701418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 701418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]