SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414523 LIMIT 1 [ RunTime:0.000798s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414523 [ RunTime:0.006171s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (527014,502294,929845,63624,787382,791045,638052,313468,941817,633008,889183,123790,55248,140887,826906,126441,323415,325191,352645,105447,512744,285385,787546,192163,948331,60770,164749,772112,798668,670474,699085,44597,958092,848715,371604,246644,3268,800685,293302,372312,869072,989856,546625,301985,1015999,276995,762684,927428,689309,565137,707290,906238,345505,14517,901175,769799,159063,552127,14623,303864) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006519s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]