SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503948 LIMIT 1 [ RunTime:0.004573s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503948 [ RunTime:0.002814s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (737111,576260,958436,301699,356312,542422,855314,930601,881180,132351,903197,378353,1012236,921376,467211,788424,287303,604494,449170,1007113,152906,383697,523302,306066,1009062,400503,973385,57826,947209,924639,764790,135400,481974,656852,241195,992158,213851,575282,898976,761222,391538,1021004,170616,590185,828902,198757,92251,633441,79012,1013733,445673,793491,840899,312902,270266,535343,302321,795059,281818,926828) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001705s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503948 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000534s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503948 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]