SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535963 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535963 [ RunTime:0.001441s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1007804,596349,971248,869144,404156,377162,348691,410613,681205,493919,585112,616181,259031,185373,560611,495931,491001,338480,17721,220139,54681,188172,583680,143949,846741,202327,358017,893416,4021,580356,840198,376328,851135,538544,971668,452457,233595,254486,898809,46155,940550,362267,325411,990156,36458,124828,1048778,998456,905768,558629,805440,523879,555434,877343,583238,444439,467923,804099,50540,216997) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535963 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535963 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]