SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413328 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413328 [ RunTime:0.001538s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (119857,879498,133392,872193,1045275,360959,635050,374799,480158,180747,1021900,917977,238475,1029281,474676,849043,382256,396939,1042167,110893,15780,161905,824572,478483,308954,314894,322749,649910,334699,457334,159670,461211,574215,212440,825316,655979,862342,736752,7114,736799,417020,935933,463070,880297,226967,855440,124826,799303,531558,839872,576823,717353,754313,591662,529584,1027221,130233,994729,347134,512928) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]