SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533424 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533424 [ RunTime:0.003032s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (535494,267143,600919,1002150,386238,393193,63432,282731,116423,673873,985960,476986,987625,983051,450893,547020,1042430,48943,714982,999700,96678,68438,447580,189503,172621,674589,432383,479491,506040,874901,158808,992163,317224,249639,562065,83866,655946,387086,987875,311284,493751,861531,547852,802241,28305,375514,310055,247641,535342,318556,105162,157548,317078,943441,38520,530747,264355,156087,663508,991971) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533424 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533424 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]