SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 323218 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 323218 [ RunTime:0.001689s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (467276,738348,756282,472154,275549,422183,518949,963807,525240,741033,512702,590499,839434,1044008,1001389,379431,267662,839645,225833,218043,568746,592909,421514,491021,986323,24482,482294,608696,482079,673831,716416,710775,97764,427424,580025,763389,766338,349689,100996,358244,303728,379650,469107,212436,735457,210300,647562,487927,70090,967505,729640,239592,70310,356210,756328,613744,423714,351504,628862,829896) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 323218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 323218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]