SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41570 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41570 [ RunTime:0.001554s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (437602,767499,238588,602901,465235,819812,174927,977214,952567,831134,535673,569676,614734,980792,116852,653911,484978,1030085,120594,61619,242969,741535,401393,405129,925203,515040,516310,465054,625780,520811,385097,267294,345790,296634,151402,860553,790241,793734,676071,192950,486136,965897,1001866,588115,264167,817845,700469,616453,946823,472287,115343,326986,592034,811827,665748,184860,594119,388115,739238,89749) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41570 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41570 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]