SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001723s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 440056 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 440056 [ RunTime:0.003005s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (433882,37200,327652,237144,1007112,305360,343519,274039,398491,299967,621165,493460,489223,439531,323646,668456,982586,86237,146511,712597,293529,81013,571185,936482,795746,653813,132170,634917,833183,7658,921286,681064,109970,825068,235173,296819,559212,296520,549806,631534,342443,194361,584497,606800,629403,91284,805542,484763,287591,366895,552010,774639,686896,741981,256628,830529,939373,1016401,293862,521298) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 440056 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 440056 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000762s ]