SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 397810 LIMIT 1 [ RunTime:0.001797s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 397810 [ RunTime:0.001425s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (523188,212804,51895,871343,521036,780692,330354,819626,454015,307008,470846,453742,315624,622948,740725,285306,41191,516148,146032,181737,179841,526048,280147,494826,825199,430276,577544,677230,765927,672196,592267,493690,809320,875914,874867,526873,1002191,1014060,613657,427793,115110,951878,525090,846886,436557,258630,753502,673404,356585,90810,395807,396311,617275,265717,957380,581099,704888,474783,304684,490934) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 397810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000526s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 397810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000689s ]