SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416027 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416027 [ RunTime:0.001744s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (870022,538950,30013,726077,462824,345789,826612,950718,361211,480677,177176,530764,970900,228888,810203,645313,636434,577698,82130,229499,867534,722112,343178,476687,806721,600861,496204,314871,548846,96335,460031,112127,481277,1018803,799612,130828,45502,574702,213294,1028594,970573,69979,383792,138356,322485,859435,893525,924248,821508,817928,216602,158286,26309,17267,254317,457426,348117,426226,678410,599189) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416027 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416027 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]