SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 304028 LIMIT 1 [ RunTime:0.000448s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 304028 [ RunTime:0.002618s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (340910,950185,171768,22664,1041973,115008,240012,948300,235875,344747,35348,754065,419539,135504,419732,275737,601670,872418,926778,432310,492863,854596,130569,513646,527493,1014451,82869,281092,637022,863918,156448,1048761,810856,112708,870647,796096,464570,556930,504793,215052,464026,136238,882042,149829,505773,33693,583461,628446,870352,458561,1009884,383254,891450,623953,72831,50140,385197,77455,529942,307065) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 304028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000636s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 304028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]