SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045040 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045040 [ RunTime:0.001296s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (114272,165369,196302,554639,4848,150317,256043,292034,732131,784679,129120,618535,229575,642798,773785,530855,193884,352860,685160,32038,420589,167931,156056,703780,241863,772090,908812,322228,640942,17984,602855,190839,387033,408134,683027,295371,904176,335202,288708,606871,405249,146807,318219,281407,168099,127126,827492,653540,727560,97128,768433,1036442,881594,1007721,524555,956866,929683,335141,1016624,107149) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001732s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000415s ]