SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001709s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030523 LIMIT 1 [ RunTime:0.002309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030523 [ RunTime:0.008552s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (411900,194153,66157,37483,173869,750767,707685,851514,883082,623675,453448,126038,240043,974474,117403,61281,831169,131209,95093,831908,288457,93791,898968,977106,340196,779983,75588,693009,974376,1016774,813085,129977,885772,840627,537266,607468,474833,370667,488170,126632,209256,622384,11647,845625,92737,705265,952560,811092,95848,993997,292333,530198,472674,383596,728249,80530,888865,34053,809529,485720) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008866s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.010105s ]