SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319431 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319431 [ RunTime:0.002944s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (762646,1035570,622848,84701,511302,779826,78963,196747,357742,414234,431191,204082,880363,344457,113453,912812,48033,120320,101608,949326,636527,1037251,940457,913391,763871,57713,866746,463408,507629,1010466,595701,993618,130211,271328,481617,428203,661269,904863,466786,359216,470626,210098,339718,180444,76057,364272,153991,760298,685089,782428,733266,8481,860579,448878,830617,722808,787069,341453,634433,581305) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319431 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319431 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]