SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040437 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040437 [ RunTime:0.001492s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (445851,211908,268469,869024,810640,702796,418346,805040,421688,531253,1004770,33107,490520,816615,681055,59239,766060,794323,8560,557927,15219,642875,980986,700506,991171,336916,817802,458282,891379,602283,86907,86937,1009702,862789,351850,969581,561484,903099,786636,928872,793209,259998,83069,826555,495656,80573,360799,196382,573899,453620,894828,875458,967229,428664,674586,677884,520845,644086,410886,851321) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000918s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040437 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001643s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040437 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]