SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 436847 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 436847 [ RunTime:0.001658s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (453060,130789,468669,396728,610320,380664,236312,185912,854295,793544,628026,310059,452786,742196,72051,792652,105174,893164,342108,5130,863860,305267,388728,108725,237023,767626,518421,435137,566493,550956,830708,221832,951524,684574,265232,708176,784674,888187,987080,119358,254803,456734,84832,711652,549704,386121,275299,304593,628319,506711,265502,212154,978652,129790,652946,22309,925998,166742,504055,899636) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 436847 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000311s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 436847 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]