SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001436s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 583611 LIMIT 1 [ RunTime:0.000561s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 583611 [ RunTime:0.003288s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (163709,828776,935916,923353,282775,997962,128829,438683,195378,838212,691010,316846,453449,279716,56069,903740,1343,22616,119450,461724,1013932,341356,729335,683640,803417,1030654,517589,619415,134945,874978,567624,857959,304227,405204,232131,164125,931384,74135,454880,225221,780164,308172,633386,671106,859370,255161,569019,1015110,185035,380921,374816,855401,261130,444715,592758,215614,149446,138101,712591,969947) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001868s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 583611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 583611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000924s ]