SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004657s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410721 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410721 [ RunTime:0.001610s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (409740,436674,160444,817200,996347,582165,700759,1578,699828,758622,283637,907109,819678,436560,711404,267918,15964,299479,754001,469554,102629,544857,956560,327293,801820,858445,338938,523880,620852,670494,771212,388214,870263,315657,139916,854246,425480,636954,314392,650871,751529,561070,890998,321359,39784,754400,396503,515411,850894,940242,287715,800535,25170,904393,177327,883058,760901,799794,1020888,446011) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410721 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410721 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]