SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445888 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445888 [ RunTime:0.001568s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (86249,544149,107608,695103,321483,448576,75106,806948,77642,250953,83091,646398,39418,501039,658414,565925,167798,270435,114497,193220,50470,65339,835598,695317,63386,570302,674380,715148,610950,551543,315091,713200,898959,11992,748175,719756,885157,865193,901981,780074,767517,853895,17226,658369,712764,45183,529461,993536,343424,302921,446097,171192,442436,195407,25797,536734,21120,541393,729889,911757) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445888 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445888 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]