SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505875 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505875 [ RunTime:0.001524s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (320560,870992,297590,680928,483537,617407,81760,358347,766108,811642,64233,375892,323929,579556,899420,341956,356808,144250,68672,367717,825580,598945,688120,377340,849221,842270,113201,560385,109753,135267,386953,783869,853527,546197,453466,896169,303315,690279,562541,29328,1014231,332998,606641,321273,693222,854838,64026,16936,533927,611304,892370,869996,443158,343563,474879,110464,955505,681719,738085,382653) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505875 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000606s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505875 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001435s ]