SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 590473 LIMIT 1 [ RunTime:0.000563s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 590473 [ RunTime:0.001977s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (114867,620975,410190,176684,569687,459451,913837,726782,883441,456712,867508,1013735,283162,601491,766395,646011,339419,40816,150960,527813,445048,872805,585952,610143,564100,257647,72249,1006105,589854,60260,502520,349148,893289,249377,848890,377716,241006,521645,185370,631962,35483,754791,96547,593228,715815,958294,128377,671570,109780,456779,217751,987487,796409,1031812,111619,708531,905454,921002,672762,19374) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 590473 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 590473 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]