SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106409 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106409 [ RunTime:0.001612s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (274064,845039,395077,1041428,280421,146157,360922,135660,1028972,85250,1020878,583332,412692,1000099,38004,41625,352288,822668,238828,175134,890243,576527,361940,460681,948836,506253,947924,828190,971031,705758,635185,959085,399290,471343,765388,247551,58866,371383,25313,824231,468636,458272,636159,450162,253105,691356,1034837,68718,219136,816186,298834,1046065,324460,218266,777259,76096,856501,597575,585097,840135) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000412s ]