SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010842 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010842 [ RunTime:0.002072s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (721453,64822,109128,654740,414604,407020,221052,955017,541326,448541,123087,754810,47472,289244,365758,494137,365539,600078,960584,514039,749636,747158,254192,38860,1019608,1022668,618868,613558,254158,658890,718288,577569,800201,369922,608466,278554,621974,345501,787694,953583,1012631,1023681,224442,1025556,417170,372223,110393,568852,198867,737874,1030461,767077,873114,914325,32247,261884,525940,987051,256563,252764) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010842 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010842 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]