SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001487s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 805271 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 805271 [ RunTime:0.002003s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (715200,621567,513294,364404,484663,364184,636641,386446,790609,794201,508924,20954,1030245,590067,29259,732099,446565,155966,477244,638187,472988,730023,846676,506646,649596,671042,384359,666599,117345,672888,625581,488022,35092,267569,192964,460632,949656,594679,367170,165254,870244,798574,67024,586043,849180,884798,144069,949498,615499,426348,546451,722777,127837,8176,471027,354244,52069,947923,1017568,171367) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 805271 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 805271 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]