SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002763s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1033983 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1033983 [ RunTime:0.001733s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (7028,579952,690344,383981,808938,715342,512968,467048,563557,349781,66273,313687,113298,483146,544984,330871,723202,952868,719243,977312,800559,856273,831099,20573,1022004,940131,124441,515924,250826,409191,797415,701744,1048651,293747,265576,822929,766030,205435,966552,640298,684426,741473,171089,162264,930155,964500,188204,1022611,642807,1020766,717068,770417,135768,863333,443723,801359,340428,1032754,475344,172570) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1033983 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1033983 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003337s ]