SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319145 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319145 [ RunTime:0.002516s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (202223,128874,801950,588433,405163,187816,762803,973640,435368,327246,888893,507187,648171,796018,933134,501609,1044286,783435,694204,573388,973785,772293,928976,689225,501973,1044020,558011,977658,798051,683058,901687,102445,652703,480702,948917,1009580,179402,517347,231303,219259,12263,325232,118344,386961,960991,894043,881012,949537,925843,216596,152655,9042,3272,748239,425283,65398,671629,751741,93777,827037) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319145 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319145 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000426s ]