SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532413 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532413 [ RunTime:0.001797s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (621365,150846,327041,829867,835541,425289,258368,733565,517075,979046,579412,576166,20909,877825,802799,840777,954254,752946,26240,978323,812544,709236,471228,561105,724517,651303,490737,643456,54543,1027191,613308,412707,415035,662761,39143,256826,150167,500178,847440,466993,918760,1022098,584441,136221,1046294,570740,987750,397020,163367,1047400,412453,324684,198779,191213,1024145,181479,1029332,167830,912277,93165) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000462s ]