SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531821 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531821 [ RunTime:0.001708s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (482057,753644,248947,124873,908688,560120,65723,662117,400396,839646,200666,548595,76239,919740,263968,125111,243480,781444,534575,863854,1006799,1006437,400688,213187,698439,833067,380921,344813,83170,974289,359334,591821,711772,909831,159441,344721,914930,167004,15196,961845,157662,462674,487225,374086,488930,377769,1036988,707068,149223,819200,359442,573793,660350,27383,672197,1001940,719310,1007826,848261,976141) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001791s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531821 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531821 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]