SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411332 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411332 [ RunTime:0.001542s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (249714,1014067,372921,278178,368451,225843,1800,138003,427947,918974,195274,258851,406654,623310,13864,950114,856896,219910,551199,583619,219579,657349,712326,158734,268817,207825,732829,791840,751452,903887,730046,182932,185713,953672,186956,585042,827654,139422,549345,475584,593559,40725,183815,330470,598458,448682,358959,252312,725794,854822,40780,877002,350380,727106,334054,517198,858489,41681,617496,227512) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411332 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411332 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]