SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010593 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010593 [ RunTime:0.001478s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (266471,15808,765066,637019,1033367,579484,140545,614642,288073,459537,726411,507694,162240,862451,1024631,624882,1044902,1000387,321986,619144,192208,502347,1017009,174510,852192,308548,960603,436730,223831,760604,359525,86757,115736,717988,758219,706424,119897,223622,1027478,549535,886594,35624,344190,843070,825818,400755,1020574,33087,894864,403122,890484,950815,578857,959039,617868,319045,523043,773342,701493,171748) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010593 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010593 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]