SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 196048 LIMIT 1 [ RunTime:0.000598s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 196048 [ RunTime:0.001923s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (79559,800927,571731,96863,248689,596851,498418,452673,551049,330814,426395,1032628,444508,105500,74356,235585,208303,517814,682973,174497,1001427,211900,274811,235435,38175,767427,511363,316284,14518,857785,950952,352712,827377,407697,631153,191815,685727,970463,375104,298333,323161,289186,285831,664969,371568,5726,603359,805460,116412,209026,756172,677080,52909,378990,868640,697590,544494,208507,615756,670257) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 196048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 196048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]