SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 810552 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 810552 [ RunTime:0.001462s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1003319,966092,278941,25714,149428,1021202,265409,1040090,197537,512047,724942,875208,500530,491931,945685,722641,381568,21444,44790,320987,326879,57801,819433,393891,13656,221946,591226,914245,308874,259075,861526,637544,192652,970120,363749,832260,403475,289398,944579,795,731172,578450,435893,846774,412619,523448,213211,421259,721542,791654,99529,945000,1046564,405785,780591,905523,890151,510565,967775,298467) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 810552 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 810552 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]