SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 247713 LIMIT 1 [ RunTime:0.000804s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 247713 [ RunTime:0.001781s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (500855,493104,46059,314525,682133,1003183,106316,806082,594437,182453,1007294,935786,497020,724533,464005,11897,291880,772406,375650,241131,871657,550718,164043,987667,174119,836134,143094,50527,1013391,733367,661950,987718,246219,453961,541199,10590,580268,867281,731245,291186,1016087,289980,995849,783829,190585,840341,892472,19940,847831,281482,167265,412127,23425,10971,814721,576706,402535,340534,178843,38212) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.023349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 247713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000586s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 247713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001541s ]