SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001443s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451307 LIMIT 1 [ RunTime:0.000526s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451307 [ RunTime:0.001973s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (663732,60546,29330,97907,186668,162871,37006,453163,627832,55890,180249,24639,332493,194757,386020,706678,978003,429230,570440,1029598,528783,786816,237436,679200,477239,877047,75847,504882,447313,504703,201284,688216,38972,454500,802610,865078,688686,415241,233898,302927,642555,377786,921809,760494,984074,799935,592841,264515,975526,51829,93471,238141,199783,288492,357818,591637,61260,525603,758765,923805) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451307 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451307 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]