SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001441s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042811 LIMIT 1 [ RunTime:0.000498s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042811 [ RunTime:0.001905s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (165787,730103,26364,942452,891459,602425,674513,559934,998638,272315,313263,917299,87890,1022427,805994,852341,363041,127604,205528,858462,336196,110336,739383,851398,621382,199227,185035,378809,148122,587652,58403,656290,300374,795005,586494,590727,905566,880395,596869,207452,779445,1029981,551774,240609,309845,679529,315928,415362,15461,930861,159679,470453,487078,453920,185089,12100,936156,934183,350837,400485) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000621s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000861s ]